package com.etc.dao;

import com.etc.dto.CommodityInventory;
import com.etc.dto.CountsStock;
import com.etc.entity.Commodity;
import com.etc.entity.Order;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface CommodityDao {

    /**
     * 通过ID查询店里商品
     * @param
     * @return
     */
    public List<Commodity> queryAllCommodity(Integer id);

    /**
     * 通过ID查询店里商品和库存
     * @param
     * @return
     */

    public  List<CommodityInventory> queryAllCommodityInventory(Integer id);



    /**
     * 通过ID查询商品存库的总库存量
     * @param
     * @return
     */
    public  List<Commodity> queryAllCount(Integer id);


    /**
     * 通过ID修改状态
     * @param
     * @return
     */
    public int modifyState(@Param("goodid") int goodid,@Param("groundingid") int groundingid);

    /**
     * 通过ID删除商品GOODS
     * @param
     * @return
     */
    public  int delectIdGoods(@Param("businessid") int businessid,@Param("goodsid") int goodsid);

    /**
     * 通过ID删除库存
     *
     * @param
     * @return
     */
    public  int delectIdGoods_sku(int goodsid);

















}
